Tabela PhLDrugProdItLotInSt

Definicja tabeli PhLDrugProdItLotInSt

Name

PhLDrugProdItLotInSt

Code

PhLDrugProdItLotInSt

Comment

 


Lista kolumn tabeli PhLDrugProdItLotInSt

Name

Code

LotInStID

LotInStID

DrugProdItemID

DrugProdItemID

Quantity

Quantity

PresentationUnitId

PresentationUnitId


Kolumna LotInStID tabeli PhLDrugProdItLotInSt

Definicja kolumny LotInStID tabeli PhLDrugProdItLotInSt

Name

LotInStID

Code

LotInStID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DrugProdItemID tabeli PhLDrugProdItLotInSt

Definicja kolumny DrugProdItemID tabeli PhLDrugProdItLotInSt

Name

DrugProdItemID

Code

DrugProdItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Quantity tabeli PhLDrugProdItLotInSt

Definicja kolumny Quantity tabeli PhLDrugProdItLotInSt

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

 


Kolumna PresentationUnitId tabeli PhLDrugProdItLotInSt

Definicja kolumny PresentationUnitId tabeli PhLDrugProdItLotInSt

Name

PresentationUnitId

Code

PresentationUnitId

Data Type

NUMBER(10)

Mandatory

No

Comment

klucz obcy do PhUnit


Lista kluczy tabeli PhLDrugProdItLotInSt

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhLDrugProdItLotInSt

Definicja klucza Identifier_1 tabeli PhLDrugProdItLotInSt

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment